SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560511 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560511 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236238,472714,945040,385436,622471,42352,676952,958719,723895,876687,1013149,108956,335049,1042303,879297,80518,778240,712119,753160,115751,738565,603059,478575,1030907,65460,946048,383970,4778,147118,144638,382117,929240,249189,304195,637400,468163,21282,272669,711333,563861,394055,98648,430553,314431,195881,194683,89563,604094,448959,346373,833245,913467,175694,546440,201259,837695,999017,525873,88646,323391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]