SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 307481 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 307481 [ RunTime:0.002591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457865,865254,699321,278562,212518,139867,964359,867601,387498,13259,117064,784810,884273,368090,190458,70883,4176,450505,1038792,1012869,765225,472442,622129,13400,177107,307581,64104,906569,926145,419050,75859,810207,970107,491784,553286,808208,254105,385090,694388,335020,712209,434475,1031490,65007,73122,448533,285415,723428,289158,980912,118661,934291,627658,868449,154881,971390,326458,68571,775011,658800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 307481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 307481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]