SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447309 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447309 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850141,156752,811521,171801,667677,273027,387389,666671,717066,533328,873220,242117,758099,694593,209768,729890,925500,349571,450640,156828,990493,946753,513938,241582,1017388,1048200,663522,894844,914091,692672,155812,385677,838690,668279,357859,156942,302557,901665,538085,399319,204269,943658,401180,417271,887824,932273,686824,34872,228903,430555,290946,851207,430073,999872,8780,24932,479094,1003913,982396,143397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]