SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406106 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406106 [ RunTime:0.008590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293889,88181,46988,442747,80443,459993,535120,86136,410037,450316,111210,711371,877913,667020,197527,808507,759283,307108,288793,244,435772,436105,738085,552937,566306,234651,296570,508472,886722,1031190,409801,471909,411084,226208,895076,618256,518754,387841,1006714,353203,272323,2941,522340,1039158,401411,990811,368349,149941,817067,999880,676802,132099,1041127,997496,463895,365576,628519,1026703,912414,902132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406106 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406106 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]