SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500230 LIMIT 1 [ RunTime:0.001642s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500230 [ RunTime:0.002855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (500040,241283,477618,352810,184483,568989,909904,540422,1006690,248915,745698,107019,678609,167761,526747,1018432,712469,1037102,98119,405194,647382,196242,512705,339411,320659,661440,750143,131480,504773,370265,417946,147443,294858,203310,126526,673982,253649,461033,703175,304946,154662,274282,829147,402753,360824,296584,460524,107625,701918,871497,792512,755878,871444,296101,1048513,1032411,866019,19113,854716,346403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500230 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500230 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003186s ]