SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023228 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023228 [ RunTime:0.001448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822460,443185,517688,243011,410217,819274,895311,175615,950522,704822,855359,893790,991404,178214,574058,65732,713230,811267,137507,925047,688346,734609,713634,982030,140422,308046,49525,8726,421563,25634,726423,933459,989817,1035159,102749,962597,62914,871122,775618,508912,748590,905003,710372,273393,312370,641020,833031,69753,499487,729757,455159,218700,593091,89432,447418,68852,37877,178051,523832,265937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]