SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401114 LIMIT 1 [ RunTime:0.003274s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401114 [ RunTime:0.003463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807180,380521,184787,22776,94253,202346,515363,450933,791645,294734,313341,939867,81073,775944,345653,854060,120495,304517,803019,757565,83082,16911,715913,862864,231472,599459,467118,322351,877311,43211,682068,644358,1539,894989,798416,704794,599035,722617,377687,488157,289532,143909,174705,223235,904581,625364,37603,538346,630469,829579,55734,566952,293985,450981,133659,274815,244751,991526,740651,746910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001625s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002346s ]