SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536417 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536417 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318769,206927,944518,904108,1015303,345495,682730,181086,400427,543869,523815,244306,104421,807532,497978,374010,28724,475887,121554,1030118,284582,136351,907723,848706,208918,246741,757659,820684,99670,414509,810612,756476,756873,138372,264557,343168,927001,562528,284435,193162,438338,754415,134971,913348,473090,415337,457801,699919,489778,630681,782400,576945,861337,206791,131177,1006207,820371,542838,630180,379234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]