SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512908 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512908 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75452,840862,146810,598824,423195,492018,606644,292623,362193,507211,493073,37910,956578,62904,252366,190096,879841,259344,297772,317609,789800,1048351,755843,733989,592191,721641,586288,380124,579775,633044,528747,618901,79681,618550,265683,809587,261890,544565,826285,256739,351767,189466,872173,351310,22630,732593,82417,100149,132788,1041369,420273,859052,20939,524526,261927,88896,998200,65650,607203,506824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]