SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505633 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505633 [ RunTime:0.002187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766252,175725,657088,545454,1018599,372812,899522,22373,226887,187511,618759,103378,855955,725251,539466,1028274,284037,713999,737175,251373,502039,1042026,905264,970904,325685,286264,173450,810166,1048472,569642,36124,568288,513838,459019,205674,699038,295164,370797,366949,889243,640158,247700,378750,313854,1046997,915861,623841,379736,658499,882772,886068,1023312,634173,1032086,522252,980157,179932,94325,880810,940608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]