SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040498 LIMIT 1 [ RunTime:0.000953s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040498 [ RunTime:0.003468s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122108,437044,806706,869354,703607,336703,353270,807049,96864,801759,1038976,303319,525348,617672,813998,313021,583685,169855,915359,447428,832444,701630,77414,37461,255362,807121,821464,20837,962773,1025393,808541,327490,172494,900374,759165,46408,807322,782547,975386,227391,611943,324944,906980,132312,403876,168076,313413,69209,126974,319796,290417,149021,363278,287842,15897,877185,497024,612472,710740,957346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]