SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520535 LIMIT 1 [ RunTime:0.001337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520535 [ RunTime:0.001361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35397,789162,649418,318905,587628,912492,534894,110286,588295,360623,548674,416814,810137,148365,734764,1040937,745067,882438,1013226,656364,587041,1007343,1025928,954870,547153,767005,253558,541294,130394,647154,557651,505109,954859,764161,291180,528710,643288,989416,496388,340552,653485,566544,327185,195767,408234,621094,834738,720364,181086,527992,56545,343819,264659,69966,481936,254534,67671,229939,1018744,795840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]