SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505143 LIMIT 1 [ RunTime:0.000567s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505143 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503547,810375,5641,72170,94192,344297,537299,464370,445477,21394,418733,210029,101977,24004,701538,10514,482439,1026531,349337,461986,946619,139316,88951,543514,967268,188838,804050,727201,400829,942010,879066,1015880,235551,937618,221096,412289,503471,211318,917114,530174,1011045,276805,603648,462749,8865,640392,933465,617688,882619,637547,377401,607178,173798,1041901,765645,895906,513068,863398,488213,520916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]