SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037053 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037053 [ RunTime:0.001433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653908,535885,1039991,168543,378582,765434,417850,910441,563878,371407,164416,7725,182159,76183,746296,863547,462874,412627,684775,251446,1031599,95264,481601,535226,79379,518369,574850,837727,629511,2056,824574,704765,578720,844674,342549,1001285,436671,839317,800284,883793,155096,446875,357600,159011,493414,190511,449513,594618,589535,619737,230952,361670,829913,121686,513624,545658,60267,224422,99008,910738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]