SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508384 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508384 [ RunTime:0.003388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753251,633428,79905,1022572,136024,276246,293034,73301,228012,328981,608488,841581,179736,889272,443606,360302,4110,959424,588795,869186,785281,240904,1041117,1044413,1001243,274522,871978,409141,777550,420175,540094,803708,235541,129973,547538,871863,609478,1028310,937135,953390,755135,915103,415549,535188,535231,342650,927226,926752,142480,588758,509882,711059,812303,129739,1009680,587185,3532,223990,814181,6866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]