SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506475 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506475 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (967509,283290,222234,648984,734947,287311,586392,744595,237516,109596,439014,402890,304355,1017742,631257,355312,312334,166881,834635,341832,987988,895740,409826,222964,909471,358764,958565,1030564,344703,939215,49666,324301,360032,754713,82710,852046,180744,957638,471517,120446,50892,1018999,655445,977171,819849,33801,440996,657675,552356,798918,280106,972941,660957,49471,666433,592767,745762,111754,958512,748553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002099s ]