SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335403 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335403 [ RunTime:0.007301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945373,441891,682605,47780,367630,250474,844486,443989,737252,668917,33282,769158,191054,336232,323296,781220,4973,548757,667914,664000,34050,766393,590392,365665,121486,1032640,395115,128691,937016,361095,839643,1026772,722986,20548,588545,426176,204583,210579,573485,1045431,171308,988902,1003018,731614,770668,785179,377938,458315,590411,61455,828424,879674,730028,307623,441723,706186,4907,130931,872715,363751) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001539s ]