SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412660 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412660 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129333,841001,140913,789552,643443,350129,243753,456879,615323,222579,747366,63304,746549,613115,410952,27805,753039,140559,648045,412963,378170,686856,221480,449899,737962,830324,539827,619809,1046025,868074,89603,696180,1038248,932513,614784,392044,32180,819931,1003269,325397,880248,415810,107823,818018,567790,738060,239383,717927,153101,327577,880119,747912,327496,498512,894159,449694,571680,454736,241891,869317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]