SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013028 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013028 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109436,605438,621141,55419,863216,728865,243279,898613,333412,507238,869454,276694,978388,448404,137027,911191,948001,5668,129284,572820,27001,665670,385536,897467,31220,215838,404158,704215,94412,802601,197584,150478,435322,256986,929198,974031,686174,899830,784897,1047283,158112,815294,177884,786622,1046802,569945,1022627,1038669,1041145,693152,933114,484738,269868,12685,230648,350468,632155,68636,739219,305621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000785s ]