SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356053 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356053 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459140,723003,72740,673966,848804,293919,987266,503092,721311,711622,779287,991749,404351,893194,159731,160443,675566,480428,644447,438990,951823,666411,737075,88543,998620,885318,984483,711317,498386,484304,707692,626635,829404,19953,4076,796466,305042,779929,56521,1010249,548946,976346,488016,149512,762355,862190,728896,166296,261499,63725,92776,744516,968272,502144,274826,829123,481351,470591,968268,130576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]