SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015923 LIMIT 1 [ RunTime:0.001211s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015923 [ RunTime:0.005510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701492,64287,981085,164708,850385,59457,969091,893888,561331,960831,470921,900404,898942,331011,116738,28209,738359,87901,292079,16442,332251,1036388,630034,770735,499473,293143,989699,500051,76773,320507,376260,690238,592321,820648,69518,842473,334833,67585,545260,35264,727068,87198,301728,763269,128495,861557,199105,615917,825541,253512,833364,994603,369420,953979,810181,82717,465043,831451,763944,201182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]