SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 814454 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 814454 [ RunTime:0.004180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103618,305778,351559,3671,212292,832362,287992,666757,1033886,83218,882149,1040823,935413,790165,647291,453994,872787,805157,840121,91602,1041885,986158,425005,462443,960372,395296,86880,170265,882585,902279,388843,634293,930000,313246,819018,361955,448299,215383,738017,724320,579893,716852,565525,572142,741447,264617,398898,260376,340664,275288,198301,228515,99861,431027,573264,673966,630738,369439,280785,673007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 814454 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 814454 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]