SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010209 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010209 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856576,259052,361738,329299,812347,431103,850643,253234,27409,834664,983299,680436,761804,138469,804812,19390,693937,828741,324443,45694,606246,363904,517069,247376,44756,212134,441582,210429,416108,18656,516906,668758,877871,779870,518260,571938,709019,312620,92019,544515,38208,925010,57160,803988,388486,423059,763289,927899,570756,322975,45721,702603,623721,64362,942734,764781,145854,819903,666310,141701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001818s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010209 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010209 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]