SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565403 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565403 [ RunTime:0.001828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689021,92968,261023,278051,336948,186239,650201,790458,758269,390349,770652,587745,272521,394161,1004097,675878,85943,120735,676257,30449,679415,981022,828303,227739,684440,791712,577757,1032360,974235,807258,481038,766137,639326,792237,765742,357393,20493,971286,918703,154452,151084,504158,188191,155477,752850,740293,19672,425168,860617,541636,226260,14531,453378,347850,1017828,416616,759903,521199,985281,770003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]