SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 579820 LIMIT 1 [ RunTime:0.000549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 579820 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414012,257911,65183,678724,76819,754681,534023,416005,748544,101906,871584,751355,999106,784071,545273,244292,608507,619745,143974,319212,667942,156876,549700,741148,688499,89219,99422,899778,731801,156709,434319,203745,335351,786212,139728,854987,847873,947791,486113,786519,982198,823791,387305,229235,566200,754862,135166,428188,693136,738310,425857,29953,281461,360774,950938,143784,656416,157410,242650,306717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 579820 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 579820 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]