SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510403 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510403 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (991343,513039,895494,121685,221877,66210,715835,874393,221418,8660,313949,267391,138185,1017549,162228,920230,437064,534610,260331,759857,905387,653191,572683,397935,1024546,934527,302528,369127,149681,116516,297907,165291,727673,636039,138282,341719,312279,139633,613610,990889,629937,186781,788984,1010323,644031,877721,186534,906310,939772,667284,837595,104835,898055,249701,22562,717000,34880,735988,894620,560635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]