SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012118 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012118 [ RunTime:0.001806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352900,847123,1033318,790619,2095,883199,436259,410403,745312,813930,615928,579181,991986,718338,725258,273254,345441,672147,884592,351743,317822,497880,451051,136174,535598,386187,55014,46821,1025500,713322,472185,963087,106135,396037,342894,802856,450293,1029607,518416,896916,633435,828388,363673,421776,662532,293923,372185,55632,88116,552241,853205,2193,267395,403362,464352,1013411,220255,346834,33984,166411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]