SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 682923 LIMIT 1 [ RunTime:0.001796s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 682923 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (606327,647248,158195,17912,783679,112633,107174,373670,9388,46308,1041018,192194,94033,118903,584810,844312,287666,331333,1012547,718763,959594,721524,881577,319272,17894,547550,952131,373674,362363,77885,410315,828364,541581,53187,832910,201994,752339,718116,492794,900146,838428,684218,576170,117683,902748,241558,245535,931988,491236,468717,704832,999882,116471,327574,576804,97955,583621,176636,852586,628370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 682923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 682923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000387s ]