SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543826 LIMIT 1 [ RunTime:0.000526s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543826 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284901,1020239,959557,334438,719789,387911,694316,462537,196462,545158,499107,74874,388575,755342,275051,1040578,985700,463170,402021,606353,1025563,630339,475448,186494,791509,432710,840494,764036,369676,190564,508823,1032986,221511,810090,356131,586312,294792,899966,1039293,111608,469595,640743,37793,454953,1020800,509497,862422,843975,706808,444215,572466,235853,1037525,347395,684850,128985,781680,106185,553674,281312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]