SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 307640 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 307640 [ RunTime:0.003475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828086,470439,330008,996587,655963,726413,765603,545572,458110,600350,410041,393130,684344,192246,930887,718293,727837,553445,276917,1003916,30012,552940,752697,427893,961263,824977,1006786,12263,345327,3427,730078,598749,788292,752904,854156,504468,355900,58865,275874,343430,133310,851285,823290,939758,735611,766957,813244,554,765480,374655,885369,178656,555186,639465,915469,444892,277613,319180,826333,586411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 307640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 307640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000387s ]