SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003638 LIMIT 1 [ RunTime:0.001047s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003638 [ RunTime:0.005231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275198,848343,249259,429829,600654,945870,395804,697359,950510,145272,723852,735057,951189,815473,206451,969738,308013,443763,1036831,820936,1031543,560409,715081,432994,257077,143845,731812,765973,47450,16115,54585,518860,636728,632671,643738,1000207,97805,697497,989778,910227,1015459,765078,27502,646851,517341,752624,955544,134157,557557,201033,554551,320214,676869,979596,863297,580913,830022,131897,644749,7597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]