SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450543 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450543 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (850918,463767,697653,770384,374842,471901,7877,420949,52366,589859,79242,1037781,500434,192961,533500,894939,746472,451814,495881,617760,720758,892047,808518,227364,1021195,971866,451627,509761,10698,1025036,883609,152553,257940,380576,697077,116579,361274,607540,44888,571509,961550,1017340,151271,779263,781587,438631,589564,768850,101406,113943,27518,928759,536330,115568,511873,144367,370177,562269,448264,926603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000592s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]