SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533476 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533476 [ RunTime:0.002016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (914620,1019611,774327,1028101,229660,358699,290367,133212,288365,510654,602327,755020,136035,824460,825651,563172,919054,997492,890001,524942,799541,20346,592692,786984,971346,333284,299790,1002796,886025,440184,275194,437422,512000,678361,483669,111042,789439,212817,219916,91746,986075,942739,763710,1041426,332273,15152,218832,874812,443542,868385,161433,965975,991638,87347,776685,604912,1023380,644763,644612,469182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]