SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510106 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510106 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405294,673003,440557,918949,582426,722032,796414,555338,774164,274940,402816,526011,744319,489662,951206,361640,593789,343920,866202,852929,763619,323047,439411,508291,66898,244943,529572,360790,380369,59459,54389,192034,230636,977683,40469,145460,741220,516860,47800,995527,94198,378288,167755,552887,405740,850439,389922,136589,702900,705573,456921,741038,15354,409956,468566,399033,943779,365151,878982,716402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]