SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319068 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319068 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044762,408028,1031420,494033,739589,514917,895485,212580,81475,658487,296458,773058,656445,962099,524662,675495,1016452,329706,628961,228091,613115,287406,721108,741269,177300,939591,779905,149140,752070,500179,534865,662287,328553,333579,433233,317307,457968,332588,227159,230658,498260,981318,276335,149178,847164,583728,302905,811389,243267,151010,363642,65591,842952,1034255,689042,170970,349828,536489,996961,521329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]