SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001813s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419888 LIMIT 1 [ RunTime:0.000585s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419888 [ RunTime:0.004103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (861169,980891,203844,426433,995297,121667,322456,214970,141649,856840,460642,887384,869022,27226,275502,504023,93897,74508,184099,1014927,354786,889240,404863,158143,162881,847411,818718,830919,665526,80534,854951,50738,512046,426309,941003,206374,1017139,566277,991024,233143,307700,802719,421632,411701,506309,908987,737880,388067,1045017,804594,1015039,619617,405218,457665,213664,294106,856967,233721,279903,1032180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419888 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419888 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001069s ]