SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53584 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53584 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895025,336641,250885,88200,300268,80419,922306,687417,516472,424710,521730,899079,879469,923515,806448,181483,712429,677164,170183,475765,659237,312027,976346,953785,388471,652614,895948,347355,968845,437111,478843,1014509,512641,39561,371614,558974,204761,319847,567652,963704,287329,409795,517544,768954,1003529,870351,46001,251523,107917,624362,664981,874774,252204,273321,215215,1038556,844161,295040,710982,318725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]