SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453201 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453201 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12008,9653,711454,624172,695179,15700,396588,547095,32041,278839,204140,333722,391816,402925,10109,671136,291099,238264,194714,302200,607327,404175,752575,741391,739022,920026,936442,687699,790276,64064,673592,204280,818830,12152,1000542,987198,83955,474470,885084,711991,707039,840690,702126,676986,66427,624647,612519,567860,1027787,1011023,598854,765432,280543,128652,173111,404508,582758,245078,217274,118983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]