SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 572610 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 572610 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627970,251697,609599,413772,1024031,45825,569971,937305,593674,929230,558658,946661,504642,107988,151568,779380,144040,969863,943465,499128,987945,881982,410514,140732,975891,714920,126066,962496,837456,450977,547915,196549,996150,315857,306578,223538,257531,963653,645052,128781,827884,478186,244350,501870,685144,1043932,966137,358757,776338,90487,794164,637340,282677,294612,690749,732630,941968,461480,351217,939489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 572610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 572610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]