SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443500 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443500 [ RunTime:0.005252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (4597,58039,293834,513025,286471,1040308,855207,209841,823937,98389,864648,140063,659814,335821,170778,840624,491477,571389,831211,629218,453304,253051,130396,184809,501065,510689,1031748,851117,23897,524790,182422,44175,683329,264368,599949,856007,217416,301618,806203,537259,223904,31842,257449,310402,528544,117799,207537,785782,120356,729753,1016272,17606,911333,707490,210322,637834,671574,203127,794960,402869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001750s ]