SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507643 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507643 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283418,63897,15494,791537,17375,51526,273717,979635,795665,704688,434569,973281,65590,934952,700506,467636,262712,542307,1000972,393726,210857,368054,1018404,238776,227958,1003864,200138,725269,29679,552058,1024157,936500,573663,47223,510641,549030,429316,207603,258715,802427,541080,345155,913240,911976,815327,136279,865382,856398,541842,841781,201050,636104,110656,84611,134430,684539,134704,187821,1041447,936317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]