SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351104 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351104 [ RunTime:0.002688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19436,438526,1020197,453522,111752,29412,200181,133922,730200,243150,222598,606710,186059,312898,244126,398248,60044,983299,443349,314703,836662,947083,895900,853484,10899,751852,504418,681799,770594,551309,33876,559064,1023853,682308,437088,957969,931118,1018076,97548,924076,886680,811664,94647,241232,741372,447509,767738,610935,133536,337367,479679,749393,82092,354827,308902,365650,366657,200976,387088,991518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]