SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267781 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267781 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642960,681944,1037354,681170,646903,116987,384114,674498,565367,686296,1019201,216585,571565,445747,963602,296567,827763,917963,447347,564641,332454,944431,203623,5052,652793,851645,850114,1021380,201846,417046,169968,82482,305621,925527,678234,793068,186073,184814,960148,488298,898565,377143,186669,673234,286709,181611,993088,279234,710324,222197,879003,299927,116755,928053,528813,8619,10922,624946,423743,747283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]