SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329969 LIMIT 1 [ RunTime:0.001155s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329969 [ RunTime:0.002248s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446353,257456,461217,461424,457233,539638,625507,150017,319048,256700,37309,763904,208361,169134,99314,87138,146606,110120,51664,109077,444444,168776,48320,81361,221960,176699,20146,328132,438238,1015087,323588,701764,830855,287137,1006010,673996,482424,1020518,872422,459587,790355,542941,424783,339723,427589,700356,272594,619286,233931,210075,974439,873222,184894,612428,487464,745326,151111,388612,856252,714807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]