SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 463421 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 463421 [ RunTime:0.002954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291079,177764,970740,403535,1010364,456681,943090,570376,270309,123766,267410,305818,9846,500466,351071,105365,145122,673709,90054,231774,171401,708704,136489,512242,7,229244,710046,95720,888570,330936,537111,878880,157548,1046259,895668,818524,32402,610281,508453,247456,999931,873463,753235,757148,880490,819146,87318,366278,539575,640883,605647,957798,792931,38469,339943,871779,41507,334705,99859,20633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 463421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 463421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]