SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544976 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544976 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844021,600810,446421,734336,1009212,45874,812659,37016,990328,1035692,2113,90361,369627,61116,852072,348263,791921,24384,963587,598114,33078,173296,599804,960005,982989,908895,306490,529489,233525,5608,184680,970573,282896,262117,966641,23886,139324,219224,384063,43339,481760,788828,664238,40355,115932,172543,576562,920498,416987,1008800,1036723,905052,573330,406920,851280,210107,1039030,93535,179254,233960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]