SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282738 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282738 [ RunTime:0.004673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618019,730809,460330,812428,764891,644489,247759,469184,761708,384918,241945,243222,814513,331487,731663,815145,1041535,926322,471899,850743,312207,486916,564749,223678,691287,689201,76818,472059,656643,816242,966394,166602,858845,711646,370280,975599,328242,986087,129396,601127,175054,40103,579619,630068,219857,409490,367255,811844,746325,503825,797330,395274,979564,454749,187719,708964,787680,537787,250805,16738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001600s ]