SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517213 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517213 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (526129,282357,766141,733219,919612,318457,599878,502411,358342,119355,474331,325521,647766,266861,715394,676896,414519,443466,384131,89427,295223,979305,979562,658386,50330,249374,895709,564348,65674,833520,836723,1012839,1012784,767304,712736,686927,580025,521002,462301,35807,28255,609416,123268,425592,907633,483999,240064,521319,522188,773248,968086,205610,462591,724109,624017,51183,330337,636425,874502,512547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]