SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423180 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423180 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24514,366825,509769,241696,199825,899437,929664,92800,996083,919094,473840,869690,632507,650256,659825,553751,465921,443688,71218,945136,991009,926077,429663,796023,1032444,15426,192189,623857,242388,609389,854816,67045,725545,176214,696516,117947,973956,671596,704769,530985,334105,466067,99215,142736,617885,43607,122983,34493,418248,244184,778410,882381,598702,4220,201431,803633,564469,838043,899411,182099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]