SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530103 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530103 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87121,22145,7370,777093,78007,1001632,1020071,550561,884427,863436,690978,395573,296545,824392,438698,1027219,424133,15615,898447,904628,736618,854608,391093,482924,344542,984128,762593,528325,457339,885092,897489,313273,806735,232032,616894,753081,1020010,1046062,599267,817593,931483,1043125,731226,244822,549061,812228,220201,92740,295082,723897,116524,226912,487536,707633,111232,233664,340880,968648,470544,85601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000775s ]