SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503682 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503682 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520023,78141,238673,947563,897828,624040,312125,357234,864692,983443,733706,965989,4715,726764,54473,301165,953270,587341,647415,531066,1039827,197725,8787,685248,923831,987426,821798,736774,371079,440370,758741,761041,798372,454196,555274,241411,1006875,403925,1018160,625042,670182,185475,17760,768494,570661,513100,207342,849753,930738,197953,26334,974877,1005312,623784,679104,244217,438255,218875,776060,544081) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503682 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503682 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]