SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004642s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545434 LIMIT 1 [ RunTime:0.001096s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545434 [ RunTime:0.002072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822214,614944,597661,382987,786608,1026842,532899,214611,957661,571339,539874,126986,106369,933371,98712,335601,612082,180686,661358,884848,534124,987634,241047,272751,582703,507545,494438,173618,878788,92692,213459,700137,1040248,573830,12786,567312,883777,19762,268051,719191,938120,444653,363061,194170,810679,783869,285759,747741,513774,457895,242931,828995,378893,5615,500123,656747,199920,30405,741385,1039416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.040489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545434 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545434 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.006846s ]