SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 844041 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 844041 [ RunTime:0.004223s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458672,549842,897406,38842,326920,411736,486414,526441,283003,1031208,812177,484733,259160,833402,116244,604598,812076,141463,822609,830409,405380,937917,653542,331407,525604,154433,75218,291716,711782,497172,865672,213818,440847,18144,768803,876616,220033,432546,425968,77693,413723,191773,318785,850932,825900,741290,759889,556914,182072,132935,120099,795152,236636,532318,409647,778135,1042885,871309,150829,544319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002814s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 844041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 844041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]