SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002561s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009009 LIMIT 1 [ RunTime:0.001015s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009009 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42844,860175,527529,635070,94161,24029,429428,652355,621828,405763,362111,745963,534457,877200,572426,199240,705058,359221,225849,93768,720249,139452,879314,44084,996561,509760,563311,443495,775015,938098,594524,900879,463637,370599,230378,778737,485699,915353,21818,917543,264737,119651,493882,906281,690794,33419,51940,8622,62509,606480,279697,278284,951372,438741,399998,415265,211770,292960,66334,252434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002997s ]