SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283864 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283864 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462284,260123,588162,823136,925397,404931,194140,827147,857219,640818,858199,598301,20014,723221,565159,643583,721862,803467,275106,348204,910924,693782,446910,705512,423004,419681,436719,251411,230222,105429,677578,223035,512716,640744,100678,975862,1039896,44739,724587,733774,303223,24738,885891,605445,285552,227837,731246,838143,140990,999074,972121,88956,377847,362340,53406,780484,438783,779250,1025491,29988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]