SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597911 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597911 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442810,521857,1025591,838650,698336,332448,699115,265697,157404,946508,346241,923447,293265,474812,172156,548584,437792,225511,156576,166161,789831,293682,902170,947188,257537,158812,212590,723186,222855,271732,536672,745718,792103,19379,949442,141909,790181,266707,520267,53972,216744,888117,463614,384129,241639,648843,532145,473120,630354,315952,288950,416943,160744,827859,681682,150654,957363,214040,444854,701535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]