SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111981 LIMIT 1 [ RunTime:0.000520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111981 [ RunTime:0.002311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010228,351693,495273,721612,756491,963723,34958,675420,1031195,1023514,798811,868051,5850,92904,307391,139168,342060,576821,647346,916439,84642,352661,45232,460466,233407,30468,737422,664899,957451,874170,638370,643024,6110,173780,517259,832724,900546,698328,868626,726712,390824,203368,211971,230587,248558,883381,929519,340580,199355,242705,107148,210485,643964,914838,923495,558054,156064,415752,995521,618601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]